/****** Object:  Stored Procedure USERGet    Script Date: Monday, December 10, 2007 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[spUSERGet]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [spUSERGet]
GO

	
	
/******************************************************************************
**		File: 
**		Name: spUSERGet
**		Desc: 
**
**		Return values:
** 
**		Called by:   
**              
**		Parameters:
**		Input							Output
**     ----------							-----------
**
**		Auth: CodeSmith
**		Date: 12/10/2007 10:20:45 PM
*******************************************************************************
**		Change History
*******************************************************************************
**		Date:		Author:				Description:
**		--------		--------				-------------------------------------------
**    
*******************************************************************************/
CREATE PROCEDURE spUSERGet
	@US_ID_PK int
AS

SELECT
	[US_ID_PK],
	[NAME],
	[LOGIN_NAME],
	[PASSWORD],
	[EMAIL],
	[USER_TYPE],
	[CUSTOMER_CODE],
	[BAR_CODE],
	[IS_ADMIN],
	[IS_ENABLED],
	[CREATED_DATE],
	[CREATED_BY],
	[UPDATED_DATE],
	[UPDATED_BY],
	[CHANGE_PWD_GUID],
	[SORT_REFERENCE1],
	[SORT_REFERENCE2],
	[DOWNLOADABLE_CSV],
	[ActiveOfficeID],
	[CountryID]
FROM
	[USER]
WHERE
	[US_ID_PK] = @US_ID_PK

GO
	

	
